﻿	CREATE TABLE SUNRISE.UVERSE_DATA 
	     (
	      ADDRESS_HOUSE_NBR VARCHAR(12),
	      ADDRESS_ID INTEGER,
	      ADDRESS_LINE_1 VARCHAR(45),
	      ADDRESS_LINE_2 VARCHAR(15),
	      ADDRESS_NUMBER_PREFIX_TXT CHAR(10),
	      ADDRESS_NUMBER_SUFFIX_TXT CHAR(5),
	      ADDRESS_SUFFIX_TYPE_CD CHAR(10),
	      ADDRESS_TYPE CHAR(20),
	      BAN VARCHAR(30),
	      CARRIER_ROUTE_TXT CHAR(6),
	      CBSA CHAR(40),
	      CBSA_CD INTEGER,
	      CITY_NM VARCHAR(50),
	      CLLI CHAR(8),
	      CLOC DECIMAL(15,0),
	      COUNTY_NM VARCHAR(30),
	      CUST_SUB_TYPE CHAR(26),
	      DMA CHAR(40),
	      DMA_CD INTEGER,
	      DVR_CNT TINYINT,
	      EMAIL_ADDR VARCHAR(255),
	      FIRST_NM VARCHAR(30),
	      FULL_NM VARCHAR(61),
	      HD_IND TINYINT,
	      HSIA_AVAIL_IND CHAR(1),
	      HSIA_SPEED CHAR(8),
	      HSIA_START_DT DATE,
	      HSIA_STATIC_IP_IND TINYINT,
	      IPTV_AVAIL_IND CHAR(1),
	      IPTV_FREE_VOD_CNT SMALLINT,
	      IPTV_PACKAGE CHAR(20),
	      IPTV_PAID_VOD_CNT SMALLINT,
	      IPTV_START_DT DATE,
	      LAST_NM VARCHAR(30),
	      LEVEL_TYPE_CD CHAR(4),
	      LEVEL_VALUE_TXT CHAR(10),
	      LMA CHAR(40),
	      LMA_CD INTEGER,
	      OVALS_LUID VARCHAR(30),
	      POC_SEX_CD CHAR(1),
	      POSTAL_BOX_NBR VARCHAR(12),
	      PULL_DATE DATE,
	      RCVR_CNT TINYINT,
	      RCVR_DA_CD CHAR(8),
	      REVENUE_HSIA DECIMAL(7,2),
	      REVENUE_IPTV DECIMAL(7,2),
	      REVENUE_OTHER_UVERSE DECIMAL(7,2),
	      REVENUE_RPT_DT DATE,
	      REVENUE_VOIP DECIMAL(7,2),
	      SAAN DECIMAL(12,2),
	      SITE_ID INTEGER,
	      STATE_CD CHAR(2),
	      STREET_DIRECTION_PREFIX_TXT CHAR(2),
	      STREET_DIRECTION_SUFFIX_TXT CHAR(2),
	      STREET_NM VARCHAR(60),
	      STRUCTURE_TYPE_CD CHAR(4),
	      STRUCTURE_VALUE_TXT CHAR(10),
	      TRAC_ID VARCHAR(10),
	      TELCO_RAAID DECIMAL(15,0),
	      UNIT_TYPE_CD CHAR(4),
	      UNIT_VALUE_TXT CHAR(10),
	      UVERSE_RAAID DECIMAL(15,0),
	      UVERSE_START_DT DATE,
	      VOIP_AVAIL_IND CHAR(1),
	      VOIP_LINE_CNT TINYINT,
	      VOIP_PLAN CHAR(28),
	      VOIP_START_DT DATE,
	      ZIP_CD CHAR(5),
	      ZIP_SUFFIX_CD CHAR(4),
	      IPTV_PREV_PACKAGE CHAR(20),
	      IPTV_ACTION CHAR(4),
	      HSIA_PREV_SPEED CHAR(8),
	      HSIA_ACTION CHAR(4),
	      VOIP_PREV_PLAN CHAR(35),
	      VOIP_ACTION CHAR(4),
		CONSTRAINT ID_PK PRIMARY KEY ( BAN )	  )
	
